-- phpMyAdmin SQL Dump
-- version 3.3.9
-- http://www.phpmyadmin.net
--
-- Host: mysql5.cws.oregonstate.edu
-- Generation Time: May 22, 2019 at 12:40 PM
-- Server version: 5.1.63
-- PHP Version: 5.3.3-7+squeeze9

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `cw_61046`
--

-- --------------------------------------------------------

--
-- Table structure for table `CodesAppArchive`
--

CREATE TABLE IF NOT EXISTS `CodesAppArchive` (
  `AppCode` text NOT NULL,
  `AppName` text NOT NULL,
  `PondAppAnal` text NOT NULL,
  `PondAppRate` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `CodesAppArchive`
--

INSERT INTO `CodesAppArchive` (`AppCode`, `AppName`, `PondAppAnal`, `PondAppRate`) VALUES
('16-20-0', 'NPK fertilizer (16-20-0)', '', 'P'),
('AC01', 'AC01 ???                                        ??? = unknown/guessed', 'H', ''),
('AC02', 'AC02 ???', 'H', ''),
('AC03', 'AC03 ???', 'H', ''),
('AC04', 'AC04 ???', 'H', ''),
('AC05', 'AC05 ???', 'H', ''),
('AC06', 'AC06 ???', 'H', ''),
('AC07', 'AC07 ???', 'H', ''),
('AC08', 'AC08 ???', 'H', ''),
('AC09', 'AC09 ???', 'H', ''),
('AC10', 'AC10 ???', 'H', ''),
('AC11', 'AC11 ???', 'H', ''),
('AC12', 'AC12 ???', 'H', ''),
('AE100', 'AE100 ???', 'H', ''),
('AE80', 'AE80 ???', 'H', ''),
('AN100', 'AN100 ???', 'H', ''),
('AN80', 'AN80 ???', 'H', ''),
('CAC', 'Calcium carbonate, CaCO3', '', 'B,E,G,I'),
('CACO3', 'Calcium carbonate, CaCO3', 'G', ''),
('CAM', 'Calcium-magnesium carbonate, CaMg(CO3)2', 'G', 'G'),
('CAO', 'Calcium oxide, CaO', '', 'B'),
('CASSAVA', 'Cassava plant material ???', 'H', 'H'),
('CHICK', 'Chicken manure, air dried, may include plant material (e.g. straw, rice hull)', 'A,B,C,E,F,G,H,I,P', 'A,B,C,E,F,G,H,I,P'),
('CHK', 'Chicken manure, air dried, may include plant material (e.g. straw, rice hull)', '', 'I'),
('CL', 'Chicken manure, air dried, may include plant material (e.g. straw, rice hull)', 'F,K', 'F,K'),
('COW', 'Cow  manure', 'F', 'F'),
('CYPERUS', 'Cyperus plant material ???', 'H', 'H'),
('DAP', 'Di-ammonium phosphate, (NH4)2-HPO4', '', 'F'),
('DGRASS', 'DGRASS ???', 'H', 'H'),
('FD1', 'Feed, type 1, protein ???', 'A,F,G', 'A,C,F,G,I,K'),
('FD2', 'Feed, type 2, protein ???', 'G', 'C,G'),
('FD3', 'Feed, type 3, protein ???', 'G', 'G'),
('FEED', 'Feed, protein ???', 'F', ''),
('GALL', 'GALL ???', '', 'F'),
('GGRASS', 'GGRASS ???', 'H', 'H'),
('HORSE', 'Horse manure: database value w/o defined and analyzed applic cmpds', 'ALL', 'ALL'),
('I0150', 'I0150 ???', '', 'K'),
('I1500', 'I1500 ???', 'K', ''),
('I16200', 'I16200 ???', '', 'G,P'),
('NA2SIO3', 'Sodium silicate, Na2SiO3', 'A', ''),
('NAC', 'Sodium carbonate, Na2CO3', '', 'C,I'),
('NAHCO3', 'Sodium bicarbonate, NaHCO3', '', 'C'),
('NH4PO4', 'Ammonium phosphate, NH4H2PO4 ???', 'P', 'P'),
('NODAT', 'AppCode for compound not given (blank data)', '', ''),
('NONE', 'No compound applied (null data)', '', ''),
('PELLET', 'Feed, pellet, protein ???', '', 'F'),
('SP', 'Super phosphate, single, double, or triple ???', 'K', ''),
('TITON', 'Titon grass ???', 'H', 'H'),
('TMP', 'Temporary sub. for TSP, see  16N20P0K ???', '', 'G'),
('TSP', 'Triple super phosphate, 0-46-0, 42% P2O5', 'A,B,C,E,F,H', 'A,B,C,E,F,H,I'),
('UREA', 'Urea nitrogren (47-0-0)', 'A,C,E,F,H,K,P', 'A,C,E,F,H,I,K,P');
